# -*- coding:utf-8 -*-
"""
Author：Administrator
Date:2021年10月12日
"""
import pandas as pd

path = '../数据文件/课件018/去重.xlsx'

data = pd.read_excel(path,index_col='序号')

# print(data.drop_duplicates(subset=['姓名'], keep='first'))
# print(data.drop_duplicates(subset=['姓名'], keep='last'))
print(data.drop_duplicates(subset=['姓名'], keep=False))